ALTER TABLE [dbo].[actionablealerts]
ADD [description] varchar(255) NULL 
GO
alter table actionablealerts add  description varchar(500);
GO

update actionablealerts set description='When the Final Audit Selection Memo Due Date is past and no final Selection Memo has been received.' where id=1;
update actionablealerts set description='When the Final Audit Due Date is past Due and no Final Audit has been received.' where id=2;
update actionablealerts set description='When the Financial Report Due Date is past Due and the Report has not yet been received .' where id=3;
update actionablealerts set description='When the Interim Audit Due Date is past Due and no Interim Audit has been received.' where id=4;
update actionablealerts set description='When the Narrative Report Due Date is past Due and the Report has not yet been received.' where id=5;
update actionablealerts set description='When the IMP Due Date is Past Due and no IMP has been Performed.' where id=6;

update actionablealerts set description='When a Payment Request has been Open for 30 days without the status being changed to "Paid" or "Cancelled".' where id=7;
update actionablealerts set description='When the status of a Payment Request has been set to "Rejected".' where id=8;

update actionablealerts set description='When an "Active" Partner Grant type project started 60 days ago and there are no related payment requests associated with this Grant.' where id=9;
update actionablealerts set description='When an "Active" Project started 60 days ago and there has been no payment Request activity for the project.' where id=10;
update actionablealerts set description='When the "Start Date" of a Partner Grant type project has been reached but the Sign Agreement has not been received from the Partner.' where id=11;

update actionablealerts set description='When the Donor Award End Date is within 90 days.' where id=12;

alter table changenotificationtype add  description varchar(500);
GO

delete from changenotificationtype where id=1;

update changenotificationtype set description='When the Status of a Payment Request changes.' where id=2;
update changenotificationtype set description='When the Management Funds amount changes.' where id=3;
update changenotificationtype set description='When the Partner Grant Funds amount changes.' where id=4;
update changenotificationtype set description='When the Start Date of a project changes.' where id=5;

update changenotificationtype set description='When the End Date of a project changes.' where id=6;
update changenotificationtype set description='When the  Grant Start Date of a project changes.' where id=7;
update changenotificationtype set description='When the Grant End Date of a project changes.' where id=8;
update changenotificationtype set description='When the Status of a project changes.' where id=9;
update changenotificationtype set description='When the Status of a Grant changes.' where id=10;

